| 1 |
SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='tour' |
0.00057792663574219 |
| 2 |
SELECT * FROM default_setting WHERE setting_id='1' |
0.0002288818359375 |
| 3 |
SELECT region_id,title,slug,country_id FROM default_region WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id IN (1,4,14,18) order by order_no asc |
0.0010361671447754 |
| 4 |
SELECT distinct country_id FROM default_region where region_id=14 LIMIT 0,1 |
9.608268737793E-5 |
| 5 |
SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='14' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.001209020614624 |
| 6 |
SELECT distinct country_id FROM default_region where region_id=5 LIMIT 0,1 |
9.2983245849609E-5 |
| 7 |
SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='5' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.0011758804321289 |
| 8 |
SELECT distinct country_id FROM default_region where region_id=6 LIMIT 0,1 |
9.2029571533203E-5 |
| 9 |
SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='6' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.001060962677002 |
| 10 |
SELECT distinct country_id FROM default_region where region_id=7 LIMIT 0,1 |
9.0122222900391E-5 |
| 11 |
SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='7' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.0013570785522461 |
| 12 |
SELECT continent_id,title,slug FROM default_continent WHERE lang_id='vn' and is_trash=0 and is_online=1 order by order_no asc |
0.0008540153503418 |
| 13 |
SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='3' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.00099992752075195 |
| 14 |
SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='4' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.0010669231414795 |
| 15 |
SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='5' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.00094795227050781 |
| 16 |
SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='6' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.00094699859619141 |
| 17 |
SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='7' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC |
0.00092911720275879 |
| 18 |
SELECT tourcat_id,title,slug FROM default_tour_category WHERE lang_id='vn' and is_trash=0 and is_online=1 and parent_id=477 order by order_no asc |
0.00089192390441895 |
| 19 |
SELECT servicecat_id,title,slug,intro,image FROM default_servicecat WHERE lang_id='vn' and is_trash=0 and is_online=1 and servicecat_id IN (7,8,9,10) |
0.00095605850219727 |
| 20 |
SELECT feature_package_id FROM default_featurepackage WHERE mod_page='cruise' and act_page='cat' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00032711029052734 |
| 21 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00011587142944336 |
| 22 |
SELECT cruise_cat_id,title,slug,image_banner FROM default_cruise_cat WHERE lang_id='vn' and is_trash=0 and is_online=1 and parent_id=0 order by order_no asc |
0.00095796585083008 |
| 23 |
SELECT tour_property_id FROM default_tour_property WHERE lang_id='vn' and is_trash=0 and is_online=1 and type='VISITORTYPE' order by order_no ASC limit 0,3 |
0.00097489356994629 |
| 24 |
SELECT distinct short FROM default_property where property_id=950 LIMIT 0,1 |
0.00010204315185547 |
| 25 |
SELECT feature_package_id FROM default_featurepackage WHERE mod_page='member' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00034499168395996 |
| 26 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
8.8930130004883E-5 |
| 27 |
SELECT feature_package_id FROM default_featurepackage WHERE mod_page='tour' and act_page='tour_departure_point' and type='customize' and type_page='' order by order_no ASC limit 0,1 |
0.00034999847412109 |
| 28 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
8.2015991210938E-5 |
| 29 |
SELECT city_id,title,banner,intro,content FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and slug='lao-cai' LIMIT 0,1 |
0.0019118785858154 |
| 30 |
SELECT guidecat_idintro,title,image FROM default_guidecat WHERE lang_id='vn' and is_trash=0 and is_online=1 order by order_no asc |
0.00090408325195312 |
| 31 |
SELECT guide_id,slug,title,publish_date FROM default_guide WHERE lang_id='vn' and is_trash=0 and is_online=1 and cat_id='' and country_id='4' and city_id='682' order by order_no asc |
0.022309064865112 |
| 32 |
SELECT region_id,title FROM default_region WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' order by order_no asc |
0.0058889389038086 |
| 33 |
SELECT tourcat_id,title FROM default_tour_category WHERE lang_id='vn' and is_trash=0 and is_online=1 order by order_no asc |
0.0010280609130859 |
| 34 |
SELECT tour_id FROM default_tour WHERE lang_id='vn' and is_trash=0 and is_online=1 and tour_id in (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='682') |
0.0010550022125244 |
| 35 |
SELECT tour_id,departure_point_id,slug,title,image,duration_type,duration_custom,number_day,number_night,list_tag_id FROM default_tour WHERE lang_id='vn' and is_trash=0 and is_online=1 and tour_id in (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='682') order by order_no asc LIMIT 0,15 |
0.0010871887207031 |
| 36 |
SELECT max(number_day) as max,min(number_day) as min FROM default_tour WHERE lang_id='vn' and is_trash=0 and is_online=1 |
0.00090909004211426 |
| 37 |
SELECT max(min_price) as max,min(min_price) as min FROM default_tour WHERE lang_id='vn' and is_trash=0 and is_online=1 |
0.001255989074707 |
| 38 |
SELECT tourcat_id,title,slug FROM default_tour_category WHERE lang_id='vn' and is_trash=0 and is_online=1 and parent_id=0 order by order_no asc |
0.0011999607086182 |
| 39 |
SELECT feature_package_id FROM default_featurepackage WHERE mod_page='page' and act_page='about' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.0003809928894043 |
| 40 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
9.4175338745117E-5 |
| 41 |
SELECT page_id,title,slug FROM default_page WHERE lang_id='vn' and is_trash=0 and is_online=1 and page_id <>'2' order by order_no asc |
0.0010240077972412 |
| 42 |
SELECT meta_id,config_value_title,config_value_intro,image,meta_index,meta_follow,image FROM default_meta WHERE lang_id='vn' and (config_link='/du-lich-trong-nuoc/du-lich-lao-cai' or config_link='/du-lich-trong-nuoc/du-lich-lao-cai') limit 1 |
0.00089693069458008 |
| 43 |
SELECT feature_package_id FROM default_featurepackage WHERE mod_page='member' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.0043048858642578 |
| 44 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00011396408081055 |
| 45 |
SELECT feature_package_id FROM default_featurepackage WHERE mod_page='blog' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00032496452331543 |
| 46 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.0032660961151123 |
| 47 |
SELECT feature_package_id FROM default_featurepackage WHERE mod_page='faqs' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00047087669372559 |
| 48 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00011897087097168 |
| 49 |
SELECT feature_package_id FROM default_featurepackage WHERE mod_page='member' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00037908554077148 |
| 50 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
9.5844268798828E-5 |
| 51 |
SELECT slug FROM default_servicecat WHERE servicecat_id='10' |
0.0001680850982666 |
| 52 |
SELECT title FROM default_servicecat WHERE servicecat_id='10' |
7.7009201049805E-5 |
| 53 |
SELECT title FROM default_servicecat WHERE servicecat_id='10' |
5.8889389038086E-5 |
| 54 |
SELECT title FROM default_country WHERE country_id='4' |
0.00017809867858887 |
| 55 |
SELECT title FROM default_country WHERE country_id='4' |
9.608268737793E-5 |
| 56 |
SELECT distinct country_id FROM default_region where region_id=14 LIMIT 0,1 |
0.00011110305786133 |
| 57 |
SELECT city_id,title,slug,country_id FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='14' and city_id<>'682' order by order_no ASC |
0.0012149810791016 |
| 58 |
SELECT title FROM default_region WHERE region_id='14' |
0.00012302398681641 |
| 59 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='966') |
0.00025391578674316 |
| 60 |
SELECT distinct country_id FROM default_region where region_id=5 LIMIT 0,1 |
0.00010395050048828 |
| 61 |
SELECT city_id,title,slug,country_id FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='5' and city_id<>'682' order by order_no ASC |
0.0012080669403076 |
| 62 |
SELECT title FROM default_region WHERE region_id='5' |
0.00011897087097168 |
| 63 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='917') |
0.00022983551025391 |
| 64 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='915') |
0.00020980834960938 |
| 65 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='914') |
0.0001981258392334 |
| 66 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='913') |
0.00021004676818848 |
| 67 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='912') |
0.00019192695617676 |
| 68 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='804') |
0.00020003318786621 |
| 69 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='895') |
0.00019001960754395 |
| 70 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='761') |
0.00018906593322754 |
| 71 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='699') |
0.00025486946105957 |
| 72 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='760') |
0.00022006034851074 |
| 73 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='698') |
0.00020694732666016 |
| 74 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='684') |
0.00019383430480957 |
| 75 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='759') |
0.00019097328186035 |
| 76 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='685') |
0.00019502639770508 |
| 77 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='683') |
0.00019216537475586 |
| 78 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='758') |
0.00021100044250488 |
| 79 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='673') |
0.00018692016601562 |
| 80 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='666') |
0.00025105476379395 |
| 81 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='700') |
0.0001990795135498 |
| 82 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='656') |
0.00018692016601562 |
| 83 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='652') |
0.00018000602722168 |
| 84 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='1') |
0.00018501281738281 |
| 85 |
SELECT distinct country_id FROM default_region where region_id=6 LIMIT 0,1 |
8.8930130004883E-5 |
| 86 |
SELECT city_id,title,slug,country_id FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='6' and city_id<>'682' order by order_no ASC |
0.0014119148254395 |
| 87 |
SELECT title FROM default_region WHERE region_id='6' |
0.00013208389282227 |
| 88 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='920') |
0.00020813941955566 |
| 89 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='919') |
0.0001978874206543 |
| 90 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='906') |
0.00019693374633789 |
| 91 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='905') |
0.00019001960754395 |
| 92 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='904') |
0.00021696090698242 |
| 93 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='805') |
0.00019598007202148 |
| 94 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='802') |
0.00023484230041504 |
| 95 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='697') |
0.00020980834960938 |
| 96 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='675') |
0.00019001960754395 |
| 97 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='670') |
0.00020503997802734 |
| 98 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='690') |
0.00019097328186035 |
| 99 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='660') |
0.00019001960754395 |
| 100 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='659') |
0.00019097328186035 |
| 101 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='654') |
0.00019097328186035 |
| 102 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='678') |
0.00020790100097656 |
| 103 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='653') |
0.00023102760314941 |
| 104 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='686') |
0.00018906593322754 |
| 105 |
SELECT distinct country_id FROM default_region where region_id=7 LIMIT 0,1 |
8.9168548583984E-5 |
| 106 |
SELECT city_id,title,slug,country_id FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='7' and city_id<>'682' order by order_no ASC |
0.0013511180877686 |
| 107 |
SELECT title FROM default_region WHERE region_id='7' |
4.6014785766602E-5 |
| 108 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='958') |
0.00020313262939453 |
| 109 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='911') |
0.00018692016601562 |
| 110 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='910') |
0.00019097328186035 |
| 111 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='909') |
0.00017690658569336 |
| 112 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='908') |
0.00017905235290527 |
| 113 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='907') |
0.00017690658569336 |
| 114 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='903') |
0.00017213821411133 |
| 115 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='803') |
0.00017094612121582 |
| 116 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='801') |
0.00018095970153809 |
| 117 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='764') |
0.00017499923706055 |
| 118 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='765') |
0.00019097328186035 |
| 119 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='763') |
0.00017905235290527 |
| 120 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='762') |
0.00017499923706055 |
| 121 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='677') |
0.00019097328186035 |
| 122 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='663') |
0.00018310546875 |
| 123 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='661') |
0.00018000602722168 |
| 124 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='658') |
0.00018095970153809 |
| 125 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='657') |
0.00017905235290527 |
| 126 |
SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='651') |
0.00017404556274414 |
| 127 |
SELECT feature_package_id FROM default_featurepackage WHERE mod_page='page' and act_page='about' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.0016481876373291 |
| 128 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00024604797363281 |
| 129 |
SELECT feature_package_id FROM default_featurepackage WHERE mod_page='testimonial' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.0005030632019043 |
| 130 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00011396408081055 |
| 131 |
SELECT feature_package_id FROM default_featurepackage WHERE mod_page='faqs' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00044918060302734 |
| 132 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00010418891906738 |
| 133 |
SELECT feature_package_id FROM default_featurepackage WHERE mod_page='download' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00036191940307617 |
| 134 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00011610984802246 |
| 135 |
SELECT feature_package_id FROM default_featurepackage WHERE mod_page='news' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00040698051452637 |
| 136 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00010395050048828 |
| 137 |
SELECT feature_package_id FROM default_featurepackage WHERE mod_page='blog' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1 |
0.00064897537231445 |
| 138 |
SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1 |
0.00035309791564941 |
